Remove Rows

Block Group:	Table Operations
Icon:	no icon

The Remove Rows block deletes rows from the input table. When the block’s trigger is invoked, rows that meet the specified criteria are deleted from the input table. The input table must be a table that can be written to, such as the value stored by a Table block.

Input/Output Properties

The following properties of the Remove Rows block can take input and give output.

invoke (trigger)
enabled (boolean)
table (table)
condition (string)

invoke causes the rows to be removed.

enabled determines whether the block is enabled.

TRUE: The rows are removed when the trigger is invoked.
FALSE: The rows are not removed.

table receives the input table from which some rows will be removed.

condition specifies the expression that determines which rows are removed. For example, to remove only the first row from the table, enter row==0.

Output Properties

The following property of the Remove Rows block can give output but cannot take input.

print (string): Returns a string that is used for errors, other notifications, and for debugging.

Example

The following images demonstrate an example of the Remove Rows block. The first image shows the block and table before invocation, and the second image shows the block and table after invocation. In this example, the rows where the status column holds “medium” are deleted when the block is invoked.